﻿/*
 Pre-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be executed before the build script.	
 create database path that corresponds to your environment				
--------------------------------------------------------------------------------------
*/

use master
go
create database [dominium] on primary 
( NAME = N'dominium', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dominium.mdf' , SIZE = 5120KB , FILEGROWTH = 1024KB )
    log on 
( NAME = N'dominium_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dominium_log.ldf' , SIZE = 2048KB , FILEGROWTH = 10%)
GO
alter database [dominium] set compatibility_level = 100
GO
alter database [dominium] set ansi_null_default off 
GO
alter database [dominium] set ansi_nulls off 
GO
alter database [dominium] set ansi_padding off 
GO
alter database [dominium] set ansi_warnings off 
GO
alter database [dominium] set arithabort off 
GO
alter database [dominium] set auto_close off 
GO
alter database [dominium] set auto_create_statistics on 
GO
alter database [dominium] set auto_shrink off 
GO
alter database [dominium] set auto_update_statistics on 
GO
alter database [dominium] set cursor_close_on_commit off 
GO
alter database [dominium] set cursor_default  GLOBAL 
GO
alter database [dominium] set concat_null_yields_null off 
GO
alter database [dominium] set numeric_roundabort off 
GO
alter database [dominium] set quoted_identifier off 
GO
alter database [dominium] set recursive_triggers off 
GO
alter database [dominium] set  disable_broker 
GO
alter database [dominium] set auto_update_statistics_async off 
GO
alter database [dominium] set date_correlation_optimization off 
GO
alter database [dominium] set parameterization SIMPLE 
GO
alter database [dominium] set  read_write 
GO
alter database [dominium] set recovery full 
GO
alter database [dominium] set  multi_user 
GO
alter database [dominium] set page_verify CHECKSUM  
GO
use [dominium]
GO
if not exists ( select name
                    from sys.filegroups
                    where is_default = 1
                        and name = N'PRIMARY' ) 
   alter database [dominium] modify filegroup [PRIMARY] default
GO

